/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package ac.GUI.archive;

import ac.settings.dataModel;
import ac.settings.dataModelurls;
import ac.settings.files;
import ac.settings.sqlQuerys;
import ac.uitls.data;
import ac.uitls.propertiesOperation;
import java.awt.Component;
import javax.swing.JPanel;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;

/**
 *The class that holds the window for the products archive. each gui class have a corresponding class
 * in the engine that do all the work for it. for example, the engine class for the product is 
 * {@link ac.engin.archive.Products Engine products class}.
 * @author ismail
 * T
 */
public class Products extends ac.ui.controls.PCLPanel implements dataModel, dataModelurls, files {

    //the engine class for this window
    ac.engin.archive.Products p = new ac.engin.archive.Products();
    //wrapper class for dealing with the properties files .
    propertiesOperation po = new propertiesOperation();
    data d = new data();

    void repupdate() {

    }
/**
 * the method that runs all initialization work. It sets up the components list that will be used to save the values in the database
 * and the corresponding columns names to save to. as well setting the table name and the default search field,
 * prepares the search panel and adjusts the labels of the components according to the selected language.
 */
    void updateTemplat() {

        //<editor-fold defaultstate="collapsed" desc="Update Templat compenets">
        p.panels = new JPanel[]{data_panel, jPsellpanel, jp_bayPric, jPanel6};

        p.index = jtb_index;
        p.deleteTabel = jtab_indexDelete;

        p.serachTabel = jtb_search;
        p.ActionsButtons.put("add", jbt_add);
        /* p.ActionsButtons.put("cancel", jbt_cancel);*/
        p.ActionsButtons.put("edit", jbt_edit);
        p.ActionsButtons.put("delete", jbt_delete);
//</editor-fold>

        p.dataComponents = new Component[]{
            jtxt_productName,
            jtxt_ProductSellPriceTo,
            jtxt_ProductbayPriceTo,
            jtxt_ProductSellPriceFrom,
            jtxt_ProductbayPriceFrom,
            pCLImage1,
            jta_productDescription,
            jcom_productCategory,
            jtxt_ProductMax,
            jtxt_ProductMin,
            jtxt_ProductCode};

        p.dataSaveFields = new String[]{
            "name",
            "sell_price_to",
            "buy_price_to",
            "sell_price_from",
            "buy_price_from",
            "image",
            "desc",
            "cat_id",
            "max_limit",
            "min_limit",
            "code"};

        p.useDataFilesTypes = new String[]{
            "",
            "",
            "",
            "",
            "",
            "file",
            "",
            "",
            "",
            "",
            "",
            ""

        };

        p.TabelString = PRODUCTS_TABLE;

        p.indexField = "name";

        ac.uitls.data d = new ac.uitls.data();
        ac.ui.utils.comBoxFills(jcom_search, p.dataSaveFields, d.updateArrayLang(p.dataSaveFields));
        p.indexTitle = po.getWord("label.productName");
        jtab_data.setTitleAt(1, po.getWord("label.thisSearch"));
        jtab_data.setTitleAt(0, po.getWord("label.home"));

        jtab_data.setTitleAt(2, po.getWord("label.threportes"));

        p.deleteTabel = jtab_indexDelete;
        jtab_data.setTitleAt(3, po.getWord("label.deletefiles"));
        p.clerPanels(false);

        jPsellpanel.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.productSellPrice")));

        jp_bayPric.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.productBuyPrice")));

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.productNumberIninventory")));

        p.perMessage = false;
        if (!p.checkpricBay()) {
            jp_bayPric.setVisible(false);

        }
        p.perMessage = false;
        if (!p.checkpricSell()) {
            jPsellpanel.setVisible(false);

        }

        p.perMessage = true;

    }
/**
 * 
 */
    void deleteAttars() {
        p.deleteTabel = jtab_indexDelete;
        jtab_data.setTitleAt(3, po.getWord("label.deletefiles"));
        jtab_data.addChangeListener(new ChangeListener() {
            public void stateChanged(ChangeEvent e) {

                if (jtab_data.getSelectedIndex() == 3) {

                    p.indexdelete();
                }
            }
        });

    }
/**
 * the constructor of the class, it provides initialization work for the window and the archive template 
 * that is used to handle the operations of the window. In general, any window should perform those operations done
 * by the method calls in the constructor.
 */
    public Products() {
        initComponents();
        updateTemplat();
        p.indexUpdate();

        onLoad();
        p.EnablePanels(false);

        jp_retportTaype.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.reptype")));
        jp_retportNamesproduct.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.choseProductName")));
        jp_retportNamesClient.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.choseClientName")));
        jp_retportNamesproductCat.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.retportNamesproductCat")));
        jp_retportcon.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.repoptions")));
        jp_retportNamesInventory.setBorder(javax.swing.BorderFactory.createTitledBorder(po.getWord("label.retportNamesInventory")));

        jtxt_ProductCode.setTable(p.TabelString);
        deleteAttars();

    }

    void craeteReportStatus(String where) {
        //   p.setPrint(REPORT_Products_status_print, sqlQuerys.SQL_ProductsAll + where);

    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jtab_data = new ac.ui.controls.PCLTabs();
        pCLPanel2 = new ac.ui.controls.PCLPanel();
        index_panel = new ac.ui.controls.PCLPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jtb_index = new ac.ui.controls.PCLTable();
        pCLToolbar1 = new ac.ui.controls.PCLToolbar();
        jbt_frist = new ac.ui.controls.PCLButton();
        jbt_prev = new ac.ui.controls.PCLButton();
        jlb_indexinfo = new ac.ui.controls.PCLLabel();
        jbt_next = new ac.ui.controls.PCLButton();
        jbt_last = new ac.ui.controls.PCLButton();
        jScrollPane4 = new javax.swing.JScrollPane();
        jtr_index = new ac.ui.controls.PCLTree();
        jScrollPane6 = new javax.swing.JScrollPane();
        data_panel = new ac.ui.controls.PCLPanel();
        pCLToolbar2 = new ac.ui.controls.PCLToolbar();
        jbt_add = new ac.ui.controls.PCLButton();
        jbt_edit = new ac.ui.controls.PCLButton();
        jbt_delete = new ac.ui.controls.PCLButton();
        jbt_print = new ac.ui.controls.PCLButton();
        jXLabel1 = new org.jdesktop.swingx.JXLabel();
        jbt_cancel = new ac.ui.controls.PCLButton();
        pCLLabel5 = new ac.ui.controls.PCLLabel();
        pCLLabel6 = new ac.ui.controls.PCLLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        jta_productDescription = new ac.ui.controls.PCLTextarea();
        jlb_type = new javax.swing.JLabel();
        pCLLabel7 = new ac.ui.controls.PCLLabel();
        jtxt_productName = new ac.ui.controls.PCLTextField();
        pCLLabel9 = new ac.ui.controls.PCLLabel();
        jcom_productCategory = new ac.ui.controls.PCLGetdata();
        pCLLabel4 = new ac.ui.controls.PCLLabel();
        jPsellpanel = new javax.swing.JPanel();
        jtxt_ProductSellPriceTo = new ac.ui.controls.PCLMoney();
        jtxt_ProductSellPriceFrom = new ac.ui.controls.PCLMoney();
        pCLLabel13 = new ac.ui.controls.PCLLabel();
        pCLLabel14 = new ac.ui.controls.PCLLabel();
        jp_bayPric = new javax.swing.JPanel();
        jtxt_ProductbayPriceTo = new ac.ui.controls.PCLMoney();
        jtxt_ProductbayPriceFrom = new ac.ui.controls.PCLMoney();
        pCLLabel15 = new ac.ui.controls.PCLLabel();
        pCLLabel16 = new ac.ui.controls.PCLLabel();
        jtxt_ProductCode = new ac.ui.controls.PCLCode();
        jPanel6 = new javax.swing.JPanel();
        jtxt_ProductMax = new ac.ui.controls.PCLMoney();
        pCLLabel8 = new ac.ui.controls.PCLLabel();
        pCLLabel12 = new ac.ui.controls.PCLLabel();
        jtxt_ProductMin = new ac.ui.controls.PCLMoney();
        pCLImage1 = new ac.ui.controls.PCLImage();
        jlb_blance = new ac.ui.controls.PCLLabel();
        pCLLabel10 = new ac.ui.controls.PCLLabel();
        pCLPanel1 = new ac.ui.controls.PCLPanel();
        jPanel1 = new javax.swing.JPanel();
        jcom_search = new ac.ui.controls.PCLcomboBox();
        pCLLabel2 = new ac.ui.controls.PCLLabel();
        pCLLabel1 = new ac.ui.controls.PCLLabel();
        pCLButton1 = new ac.ui.controls.PCLButton();
        jtxt_search = new ac.ui.controls.PCLTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        jtr_search = new ac.ui.controls.PCLTree();
        jPanel2 = new javax.swing.JPanel();
        pCLToolbar8 = new ac.ui.controls.PCLToolbar();
        jbt_edit1 = new ac.ui.controls.PCLButton();
        jbt_delete1 = new ac.ui.controls.PCLButton();
        jbt_print1 = new ac.ui.controls.PCLButton();
        jScrollPane5 = new javax.swing.JScrollPane();
        jtb_search = new ac.ui.controls.PCLTable();
        jPanel5 = new javax.swing.JPanel();
        jp_retportNamesproduct = new ac.ui.controls.PCLPanel();
        jcom_produest = new ac.ui.controls.PCLGetdata();
        pCLLabel17 = new ac.ui.controls.PCLLabel();
        jp_retportTaype = new ac.ui.controls.PCLPanel();
        jScrollPane8 = new javax.swing.JScrollPane();
        jtr_rep_type = new ac.ui.controls.PCLTree();
        jp_retportcon = new ac.ui.controls.PCLPanel();
        jd_rep_view = new ac.ui.controls.PCLButton();
        jd_rep_to = new ac.ui.controls.PCLDate();
        pCLLabel22 = new ac.ui.controls.PCLLabel();
        jd_rep_from = new ac.ui.controls.PCLDate();
        pCLLabel21 = new ac.ui.controls.PCLLabel();
        jlb_repTitle = new ac.ui.controls.PCLLabel();
        jp_retportNamesClient = new ac.ui.controls.PCLPanel();
        jcom_client = new ac.ui.controls.PCLGetdata();
        pCLLabel18 = new ac.ui.controls.PCLLabel();
        jp_retportNamesproductCat = new ac.ui.controls.PCLPanel();
        pCLLabel19 = new ac.ui.controls.PCLLabel();
        jcom_productCategory1 = new ac.ui.controls.PCLGetdata();
        jp_retportNamesInventory = new ac.ui.controls.PCLPanel();
        pCLLabel20 = new ac.ui.controls.PCLLabel();
        jcom_inventory = new ac.ui.controls.PCLGetdataFull();
        pCLPanel3 = new ac.ui.controls.PCLPanel();
        jScrollPane11 = new javax.swing.JScrollPane();
        jtab_indexDelete = new ac.ui.controls.PCLTable();
        pCLToolbar9 = new ac.ui.controls.PCLToolbar();
        jbt_remove = new ac.ui.controls.PCLButton();
        jbt_removeAll = new ac.ui.controls.PCLButton();
        jbt_restore = new ac.ui.controls.PCLButton();
        jbt_restoreAll = new ac.ui.controls.PCLButton();

        setType("products");

        jtab_data.setTabPlacement(javax.swing.JTabbedPane.RIGHT);

        index_panel.setPreferredSize(new java.awt.Dimension(200, 282));

        jtb_index.setType("index");
        jtb_index.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jtb_indexMouseClicked(evt);
            }
        });
        jtb_index.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jtb_indexKeyPressed(evt);
            }
            public void keyReleased(java.awt.event.KeyEvent evt) {
                jtb_indexKeyReleased(evt);
            }
            public void keyTyped(java.awt.event.KeyEvent evt) {
                jtb_indexKeyTyped(evt);
            }
        });
        jScrollPane1.setViewportView(jtb_index);

        pCLToolbar1.setRollover(true);

        jbt_frist.setIcon(new javax.swing.ImageIcon(getClass().getResource("/ac/images/last.png"))); // NOI18N
        jbt_frist.setFocusable(false);
        jbt_frist.setHorizontalTextPosition(0);
        jbt_frist.setMargin(new java.awt.Insets(5, 10, 5, 10));
        jbt_frist.setVerticalTextPosition(3);
        jbt_frist.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_fristActionPerformed(evt);
            }
        });
        pCLToolbar1.add(jbt_frist);

        jbt_prev.setIcon(new javax.swing.ImageIcon(getClass().getResource("/ac/images/next.png"))); // NOI18N
        jbt_prev.setFocusable(false);
        jbt_prev.setHorizontalTextPosition(0);
        jbt_prev.setMargin(new java.awt.Insets(5, 10, 5, 10));
        jbt_prev.setVerticalTextPosition(3);
        jbt_prev.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jbt_prevMouseClicked(evt);
            }
        });
        jbt_prev.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_prevActionPerformed(evt);
            }
        });
        pCLToolbar1.add(jbt_prev);

        jlb_indexinfo.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        jlb_indexinfo.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jlb_indexinfo.setText("/");
        jlb_indexinfo.setMaximumSize(new java.awt.Dimension(70, 25));
        jlb_indexinfo.setType("rowData");
        pCLToolbar1.add(jlb_indexinfo);

        jbt_next.setIcon(new javax.swing.ImageIcon(getClass().getResource("/ac/images/prev.png"))); // NOI18N
        jbt_next.setFocusable(false);
        jbt_next.setHorizontalTextPosition(0);
        jbt_next.setMargin(new java.awt.Insets(5, 10, 5, 10));
        jbt_next.setVerticalTextPosition(3);
        jbt_next.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_nextActionPerformed(evt);
            }
        });
        pCLToolbar1.add(jbt_next);

        jbt_last.setIcon(new javax.swing.ImageIcon(getClass().getResource("/ac/images/frist.png"))); // NOI18N
        jbt_last.setFocusable(false);
        jbt_last.setHorizontalTextPosition(0);
        jbt_last.setMargin(new java.awt.Insets(5, 10, 5, 10));
        jbt_last.setVerticalTextPosition(3);
        jbt_last.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_lastActionPerformed(evt);
            }
        });
        pCLToolbar1.add(jbt_last);

        jtr_index.setAddtype("productsCat");
        javax.swing.tree.DefaultMutableTreeNode treeNode1 = new javax.swing.tree.DefaultMutableTreeNode("root");
        jtr_index.setModel(new javax.swing.tree.DefaultTreeModel(treeNode1));
        jtr_index.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(javax.swing.event.TreeSelectionEvent evt) {
                jtr_indexValueChanged(evt);
            }
        });
        jScrollPane4.setViewportView(jtr_index);

        javax.swing.GroupLayout index_panelLayout = new javax.swing.GroupLayout(index_panel);
        index_panel.setLayout(index_panelLayout);
        index_panelLayout.setHorizontalGroup(
            index_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, index_panelLayout.createSequentialGroup()
                .addGroup(index_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(pCLToolbar1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                    .addGroup(javax.swing.GroupLayout.Alignment.LEADING, index_panelLayout.createSequentialGroup()
                        .addContainerGap()
                        .addGroup(index_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE))))
                .addGap(13, 13, 13))
        );
        index_panelLayout.setVerticalGroup(
            index_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(index_panelLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 154, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(pCLToolbar1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
        );

        jScrollPane6.setBorder(null);

        data_panel.setBorder(javax.swing.BorderFactory.createEtchedBorder());

        pCLToolbar2.setRollover(true);

        jbt_add.setType("add");
        jbt_add.setFocusable(false);
        jbt_add.setText("jbt_add");
        jbt_add.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_addActionPerformed(evt);
            }
        });
        pCLToolbar2.add(jbt_add);

        jbt_edit.setType("edit");
        jbt_edit.setFocusable(false);
        jbt_edit.setText("jbt_edit");
        jbt_edit.setVerticalTextPosition(3);
        jbt_edit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_editActionPerformed(evt);
            }
        });
        pCLToolbar2.add(jbt_edit);

        jbt_delete.setType("delete");
        jbt_delete.setFocusable(false);
        jbt_delete.setText("jbt_delete");
        jbt_delete.setVerticalTextPosition(3);
        jbt_delete.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_deleteActionPerformed(evt);
            }
        });
        pCLToolbar2.add(jbt_delete);

        jbt_print.setType("print");
        jbt_print.setFocusable(false);
        jbt_print.setText("jbt_print");
        jbt_print.setVerticalTextPosition(3);
        jbt_print.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_printActionPerformed(evt);
            }
        });
        pCLToolbar2.add(jbt_print);

        jXLabel1.setBorder(javax.swing.BorderFactory.createCompoundBorder());
        jXLabel1.setIconTextGap(0);
        jXLabel1.setMaximumSize(new java.awt.Dimension(50, 14));
        jXLabel1.setPreferredSize(new java.awt.Dimension(50, 14));
        pCLToolbar2.add(jXLabel1);

        jbt_cancel.setType("cancel");
        jbt_cancel.setFocusable(false);
        jbt_cancel.setText("jbt_cancel");
        jbt_cancel.setVerticalTextPosition(3);
        jbt_cancel.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_cancelActionPerformed(evt);
            }
        });
        pCLToolbar2.add(jbt_cancel);

        pCLLabel5.setText("jlb_productName");

        pCLLabel6.setText("jlb_productDescription");

        jta_productDescription.setColumns(20);
        jta_productDescription.setRows(5);
        jScrollPane2.setViewportView(jta_productDescription);

        pCLLabel7.setText("jlb_productCategory");

        jtxt_productName.setRequired(true);

        pCLLabel9.setText("jlb_ProductImage");

        jcom_productCategory.setAddtype("productsCat");
        jcom_productCategory.setRequired(true);
        jcom_productCategory.setCategory(true);

        pCLLabel4.setText("jlb_productCode");

        jPsellpanel.setBorder(javax.swing.BorderFactory.createTitledBorder("jlb_productSellPrice"));

        pCLLabel13.setText("jlb_from");

        pCLLabel14.setText("jlb_to");

        javax.swing.GroupLayout jPsellpanelLayout = new javax.swing.GroupLayout(jPsellpanel);
        jPsellpanel.setLayout(jPsellpanelLayout);
        jPsellpanelLayout.setHorizontalGroup(
            jPsellpanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPsellpanelLayout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(pCLLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductSellPriceFrom, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(2, 2, 2)
                .addComponent(pCLLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductSellPriceTo, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18))
        );
        jPsellpanelLayout.setVerticalGroup(
            jPsellpanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPsellpanelLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPsellpanelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jtxt_ProductSellPriceTo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jtxt_ProductSellPriceFrom, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(pCLLabel13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(12, 12, 12))
        );

        jp_bayPric.setBorder(javax.swing.BorderFactory.createTitledBorder("jlb_productBuyPrice"));

        pCLLabel15.setText("jlb_from");

        pCLLabel16.setText("jlb_to");

        javax.swing.GroupLayout jp_bayPricLayout = new javax.swing.GroupLayout(jp_bayPric);
        jp_bayPric.setLayout(jp_bayPricLayout);
        jp_bayPricLayout.setHorizontalGroup(
            jp_bayPricLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jp_bayPricLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductbayPriceFrom, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(pCLLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductbayPriceTo, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(16, Short.MAX_VALUE))
        );
        jp_bayPricLayout.setVerticalGroup(
            jp_bayPricLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_bayPricLayout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jp_bayPricLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jtxt_ProductbayPriceTo, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jtxt_ProductbayPriceFrom, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(pCLLabel15, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(12, 12, 12))
        );

        jtxt_ProductCode.setAuto(true);
        jtxt_ProductCode.setChiked(true);

        jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder("jlb_productBuyPrice"));

        pCLLabel8.setText("jlb_productMax");

        pCLLabel12.setText("jlb_productMin");

        javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
        jPanel6.setLayout(jPanel6Layout);
        jPanel6Layout.setHorizontalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel6Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductMax, javax.swing.GroupLayout.PREFERRED_SIZE, 96, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(8, 8, 8)
                .addComponent(pCLLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_ProductMin, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(14, Short.MAX_VALUE))
        );
        jPanel6Layout.setVerticalGroup(
            jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel6Layout.createSequentialGroup()
                .addContainerGap(21, Short.MAX_VALUE)
                .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jtxt_ProductMax, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jtxt_ProductMin, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );

        jlb_blance.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
        jlb_blance.setText("0");
        jlb_blance.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
        jlb_blance.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jlb_blanceMouseClicked(evt);
            }
        });

        pCLLabel10.setText("jlb_balance");

        javax.swing.GroupLayout data_panelLayout = new javax.swing.GroupLayout(data_panel);
        data_panel.setLayout(data_panelLayout);
        data_panelLayout.setHorizontalGroup(
            data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(data_panelLayout.createSequentialGroup()
                .addGap(10, 10, 10)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(pCLLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(data_panelLayout.createSequentialGroup()
                        .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, data_panelLayout.createSequentialGroup()
                                .addGap(6, 6, 6)
                                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jcom_productCategory, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 321, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(jtxt_productName, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 321, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(18, 18, 18))
                            .addGroup(data_panelLayout.createSequentialGroup()
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(jPsellpanel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(jp_bayPric, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                .addGap(18, 18, 18)))
                        .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(data_panelLayout.createSequentialGroup()
                                .addGap(0, 0, Short.MAX_VALUE)
                                .addComponent(jlb_type, javax.swing.GroupLayout.PREFERRED_SIZE, 1, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(58, 58, 58))
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, data_panelLayout.createSequentialGroup()
                                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                    .addComponent(pCLLabel4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(jtxt_ProductCode, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                .addContainerGap())
                            .addGroup(data_panelLayout.createSequentialGroup()
                                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                        .addComponent(pCLLabel9, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                        .addComponent(pCLImage1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 121, Short.MAX_VALUE)
                                        .addComponent(jlb_blance, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                    .addComponent(pCLLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(0, 91, Short.MAX_VALUE))))
                    .addGroup(data_panelLayout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jScrollPane2)
                        .addContainerGap())))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, data_panelLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLToolbar2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addGap(56, 56, 56))
        );

        data_panelLayout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jPanel6, jPsellpanel, jp_bayPric});

        data_panelLayout.setVerticalGroup(
            data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(data_panelLayout.createSequentialGroup()
                .addGap(6, 6, 6)
                .addComponent(pCLLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jtxt_productName, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(pCLLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jtxt_ProductCode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(pCLLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jcom_productCategory, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(pCLLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(data_panelLayout.createSequentialGroup()
                        .addComponent(jPsellpanel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jp_bayPric, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(data_panelLayout.createSequentialGroup()
                        .addComponent(pCLImage1, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(pCLLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jlb_blance, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(data_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(pCLLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jlb_type, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(21, 21, 21)
                .addComponent(pCLToolbar2, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE))
        );

        data_panelLayout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jPanel6, jPsellpanel, jp_bayPric});

        jScrollPane6.setViewportView(data_panel);

        javax.swing.GroupLayout pCLPanel2Layout = new javax.swing.GroupLayout(pCLPanel2);
        pCLPanel2.setLayout(pCLPanel2Layout);
        pCLPanel2Layout.setHorizontalGroup(
            pCLPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(pCLPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(index_panel, javax.swing.GroupLayout.PREFERRED_SIZE, 263, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane6, javax.swing.GroupLayout.DEFAULT_SIZE, 601, Short.MAX_VALUE)
                .addContainerGap())
        );
        pCLPanel2Layout.setVerticalGroup(
            pCLPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(pCLPanel2Layout.createSequentialGroup()
                .addGroup(pCLPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(index_panel, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 502, Short.MAX_VALUE)
                    .addComponent(jScrollPane6, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 502, Short.MAX_VALUE))
                .addContainerGap())
        );

        jtab_data.addTab("jtab_home", pCLPanel2);

        jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(java.awt.Color.gray));

        pCLLabel2.setText("jlb_searchWord");

        pCLLabel1.setText("jlb_searchIn");

        pCLButton1.setType("search");
        pCLButton1.setText("jbt_search");
        pCLButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                pCLButton1ActionPerformed(evt);
            }
        });

        jtr_search.setAddtype("productsCat");
        jtr_search.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(javax.swing.event.TreeSelectionEvent evt) {
                jtr_searchValueChanged(evt);
            }
        });
        jScrollPane3.setViewportView(jtr_search);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane3)
            .addComponent(pCLButton1, javax.swing.GroupLayout.DEFAULT_SIZE, 202, Short.MAX_VALUE)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jtxt_search, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jcom_search, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(pCLLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(pCLLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(0, 0, Short.MAX_VALUE))))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 348, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(pCLLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcom_search, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(12, 12, 12)
                .addComponent(pCLLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jtxt_search, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(pCLButton1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        pCLToolbar8.setRollover(true);

        jbt_edit1.setType("edit");
        jbt_edit1.setFocusable(false);
        jbt_edit1.setText("jbt_edit");
        jbt_edit1.setVerticalTextPosition(3);
        jbt_edit1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_edit1ActionPerformed(evt);
            }
        });
        pCLToolbar8.add(jbt_edit1);

        jbt_delete1.setType("delete");
        jbt_delete1.setFocusable(false);
        jbt_delete1.setText("jbt_delete");
        jbt_delete1.setVerticalTextPosition(3);
        jbt_delete1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_delete1ActionPerformed(evt);
            }
        });
        pCLToolbar8.add(jbt_delete1);

        jbt_print1.setType("print");
        jbt_print1.setFocusable(false);
        jbt_print1.setText("jbt_print");
        jbt_print1.setVerticalTextPosition(3);
        jbt_print1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_print1ActionPerformed(evt);
            }
        });
        pCLToolbar8.add(jbt_print1);

        jtb_search.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {

            }
        ));
        jtb_search.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jtb_searchMouseClicked(evt);
            }
        });
        jScrollPane5.setViewportView(jtb_search);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(pCLToolbar8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jScrollPane5, javax.swing.GroupLayout.DEFAULT_SIZE, 674, Short.MAX_VALUE))
                .addGap(0, 0, 0))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(pCLToolbar8, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane5, javax.swing.GroupLayout.DEFAULT_SIZE, 462, Short.MAX_VALUE)
                .addContainerGap())
        );

        javax.swing.GroupLayout pCLPanel1Layout = new javax.swing.GroupLayout(pCLPanel1);
        pCLPanel1.setLayout(pCLPanel1Layout);
        pCLPanel1Layout.setHorizontalGroup(
            pCLPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(pCLPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(676, Short.MAX_VALUE))
            .addGroup(pCLPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, pCLPanel1Layout.createSequentialGroup()
                    .addGap(216, 216, 216)
                    .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
        );
        pCLPanel1Layout.setVerticalGroup(
            pCLPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(pCLPanel1Layout.createSequentialGroup()
                .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGap(1, 1, 1))
            .addGroup(pCLPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jtab_data.addTab("jtab_index", pCLPanel1);

        jp_retportNamesproduct.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));

        jcom_produest.setAddtype("products");
        jcom_produest.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcom_produestActionPerformed(evt);
            }
        });
        jcom_produest.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jcom_produestMouseClicked(evt);
            }
        });

        pCLLabel17.setText("jlb_product");

        javax.swing.GroupLayout jp_retportNamesproductLayout = new javax.swing.GroupLayout(jp_retportNamesproduct);
        jp_retportNamesproduct.setLayout(jp_retportNamesproductLayout);
        jp_retportNamesproductLayout.setHorizontalGroup(
            jp_retportNamesproductLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesproductLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel17, javax.swing.GroupLayout.DEFAULT_SIZE, 208, Short.MAX_VALUE)
                .addContainerGap())
            .addComponent(jcom_produest, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        jp_retportNamesproductLayout.setVerticalGroup(
            jp_retportNamesproductLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesproductLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel17, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcom_produest, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jp_retportTaype.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));
        jp_retportTaype.setPreferredSize(new java.awt.Dimension(200, 282));

        jtr_rep_type.setAddtype("products_reportes");
        treeNode1 = new javax.swing.tree.DefaultMutableTreeNode("root");
        jtr_rep_type.setModel(new javax.swing.tree.DefaultTreeModel(treeNode1));
        jtr_rep_type.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(javax.swing.event.TreeSelectionEvent evt) {
                jtr_rep_typeValueChanged(evt);
            }
        });
        jScrollPane8.setViewportView(jtr_rep_type);

        javax.swing.GroupLayout jp_retportTaypeLayout = new javax.swing.GroupLayout(jp_retportTaype);
        jp_retportTaype.setLayout(jp_retportTaypeLayout);
        jp_retportTaypeLayout.setHorizontalGroup(
            jp_retportTaypeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane8, javax.swing.GroupLayout.DEFAULT_SIZE, 334, Short.MAX_VALUE)
        );
        jp_retportTaypeLayout.setVerticalGroup(
            jp_retportTaypeLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportTaypeLayout.createSequentialGroup()
                .addComponent(jScrollPane8)
                .addContainerGap())
        );

        jp_retportcon.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));

        jd_rep_view.setType("viewReport");
        jd_rep_view.setText("jbt_viewReport");
        jd_rep_view.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jd_rep_viewActionPerformed(evt);
            }
        });

        pCLLabel22.setText("jlb_To");

        pCLLabel21.setText("jlb_From");

        javax.swing.GroupLayout jp_retportconLayout = new javax.swing.GroupLayout(jp_retportcon);
        jp_retportcon.setLayout(jp_retportconLayout);
        jp_retportconLayout.setHorizontalGroup(
            jp_retportconLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jd_rep_view, javax.swing.GroupLayout.DEFAULT_SIZE, 266, Short.MAX_VALUE)
            .addComponent(jd_rep_to, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addComponent(jd_rep_from, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(jp_retportconLayout.createSequentialGroup()
                .addComponent(pCLLabel21, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(0, 0, Short.MAX_VALUE))
            .addGroup(jp_retportconLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel22, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jp_retportconLayout.setVerticalGroup(
            jp_retportconLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportconLayout.createSequentialGroup()
                .addGap(17, 17, 17)
                .addComponent(pCLLabel21, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jd_rep_from, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(pCLLabel22, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jd_rep_to, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(62, 62, 62)
                .addComponent(jd_rep_view, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addGap(235, 235, 235))
        );

        jlb_repTitle.setBorder(javax.swing.BorderFactory.createEtchedBorder());
        jlb_repTitle.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jlb_repTitle.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
        jlb_repTitle.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);

        jp_retportNamesClient.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));

        jcom_client.setAddtype("clients");
        jcom_client.setToolTipText("");
        jcom_client.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcom_clientActionPerformed(evt);
            }
        });

        pCLLabel18.setText("jlb_client");

        javax.swing.GroupLayout jp_retportNamesClientLayout = new javax.swing.GroupLayout(jp_retportNamesClient);
        jp_retportNamesClient.setLayout(jp_retportNamesClientLayout);
        jp_retportNamesClientLayout.setHorizontalGroup(
            jp_retportNamesClientLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesClientLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(176, Short.MAX_VALUE))
            .addComponent(jcom_client, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        jp_retportNamesClientLayout.setVerticalGroup(
            jp_retportNamesClientLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesClientLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcom_client, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jp_retportNamesproductCat.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));

        pCLLabel19.setText("jlb_productCategory");

        jcom_productCategory1.setAddtype("productsCat");
        jcom_productCategory1.setCategory(true);

        javax.swing.GroupLayout jp_retportNamesproductCatLayout = new javax.swing.GroupLayout(jp_retportNamesproductCat);
        jp_retportNamesproductCat.setLayout(jp_retportNamesproductCatLayout);
        jp_retportNamesproductCatLayout.setHorizontalGroup(
            jp_retportNamesproductCatLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesproductCatLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel19, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(119, Short.MAX_VALUE))
            .addComponent(jcom_productCategory1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        jp_retportNamesproductCatLayout.setVerticalGroup(
            jp_retportNamesproductCatLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesproductCatLayout.createSequentialGroup()
                .addContainerGap()
                .addComponent(pCLLabel19, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcom_productCategory1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        jp_retportNamesInventory.setBorder(javax.swing.BorderFactory.createTitledBorder("aaaaa"));

        pCLLabel20.setText("jlb_inventoryTitle");

        jcom_inventory.setAddtype("inventory");
        jcom_inventory.setCategory(true);
        jcom_inventory.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcom_inventoryActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jp_retportNamesInventoryLayout = new javax.swing.GroupLayout(jp_retportNamesInventory);
        jp_retportNamesInventory.setLayout(jp_retportNamesInventoryLayout);
        jp_retportNamesInventoryLayout.setHorizontalGroup(
            jp_retportNamesInventoryLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(pCLLabel20, javax.swing.GroupLayout.DEFAULT_SIZE, 228, Short.MAX_VALUE)
            .addComponent(jcom_inventory, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        jp_retportNamesInventoryLayout.setVerticalGroup(
            jp_retportNamesInventoryLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jp_retportNamesInventoryLayout.createSequentialGroup()
                .addComponent(pCLLabel20, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jcom_inventory, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel5Layout.createSequentialGroup()
                        .addComponent(jp_retportTaype, javax.swing.GroupLayout.DEFAULT_SIZE, 346, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jp_retportNamesClient, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jp_retportNamesproduct, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jp_retportNamesproductCat, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jp_retportNamesInventory, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jp_retportcon, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                    .addComponent(jlb_repTitle, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jlb_repTitle, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jp_retportTaype, javax.swing.GroupLayout.DEFAULT_SIZE, 467, Short.MAX_VALUE)
                    .addComponent(jp_retportcon, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(jPanel5Layout.createSequentialGroup()
                        .addGap(5, 5, 5)
                        .addComponent(jp_retportNamesproductCat, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jp_retportNamesproduct, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jp_retportNamesClient, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jp_retportNamesInventory, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addContainerGap())))
        );

        jtab_data.addTab("tab3", jPanel5);

        jtab_indexDelete.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {

            }
        ));
        jtab_indexDelete.setType("index");
        jtab_indexDelete.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jtab_indexDeleteMouseClicked(evt);
            }
        });
        jtab_indexDelete.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
            public void propertyChange(java.beans.PropertyChangeEvent evt) {
                jtab_indexDeletePropertyChange(evt);
            }
        });
        jtab_indexDelete.addInputMethodListener(new java.awt.event.InputMethodListener() {
            public void caretPositionChanged(java.awt.event.InputMethodEvent evt) {
                jtab_indexDeleteCaretPositionChanged(evt);
            }
            public void inputMethodTextChanged(java.awt.event.InputMethodEvent evt) {
            }
        });
        jtab_indexDelete.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jtab_indexDeleteKeyPressed(evt);
            }
            public void keyReleased(java.awt.event.KeyEvent evt) {
                jtab_indexDeleteKeyReleased(evt);
            }
            public void keyTyped(java.awt.event.KeyEvent evt) {
                jtab_indexDeleteKeyTyped(evt);
            }
        });
        jtab_indexDelete.addVetoableChangeListener(new java.beans.VetoableChangeListener() {
            public void vetoableChange(java.beans.PropertyChangeEvent evt)throws java.beans.PropertyVetoException {
                jtab_indexDeleteVetoableChange(evt);
            }
        });
        jScrollPane11.setViewportView(jtab_indexDelete);

        pCLToolbar9.setRollover(true);

        jbt_remove.setType("remove");
        jbt_remove.setFocusable(false);
        jbt_remove.setText("jbt_remove");
        jbt_remove.setVerticalTextPosition(3);
        jbt_remove.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_removeActionPerformed(evt);
            }
        });
        pCLToolbar9.add(jbt_remove);

        jbt_removeAll.setType("removeAll");
        jbt_removeAll.setFocusable(false);
        jbt_removeAll.setText("jbt_removeAll");
        jbt_removeAll.setVerticalTextPosition(3);
        jbt_removeAll.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_removeAllActionPerformed(evt);
            }
        });
        pCLToolbar9.add(jbt_removeAll);

        jbt_restore.setType("restore");
        jbt_restore.setFocusable(false);
        jbt_restore.setText("jbt_restore");
        jbt_restore.setVerticalTextPosition(3);
        jbt_restore.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_restoreActionPerformed(evt);
            }
        });
        pCLToolbar9.add(jbt_restore);

        jbt_restoreAll.setType("restoreAll");
        jbt_restoreAll.setFocusable(false);
        jbt_restoreAll.setText("jbt_restoreAll");
        jbt_restoreAll.setVerticalTextPosition(3);
        jbt_restoreAll.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jbt_restoreAllActionPerformed(evt);
            }
        });
        pCLToolbar9.add(jbt_restoreAll);

        javax.swing.GroupLayout pCLPanel3Layout = new javax.swing.GroupLayout(pCLPanel3);
        pCLPanel3.setLayout(pCLPanel3Layout);
        pCLPanel3Layout.setHorizontalGroup(
            pCLPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane11, javax.swing.GroupLayout.DEFAULT_SIZE, 890, Short.MAX_VALUE)
            .addComponent(pCLToolbar9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        pCLPanel3Layout.setVerticalGroup(
            pCLPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, pCLPanel3Layout.createSequentialGroup()
                .addComponent(pCLToolbar9, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jScrollPane11, javax.swing.GroupLayout.DEFAULT_SIZE, 468, Short.MAX_VALUE))
        );

        jtab_data.addTab("tab4", pCLPanel3);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jtab_data, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jtab_data, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
    }// </editor-fold>//GEN-END:initComponents
/**
 * the method that provides the search capability to the class. It gets the search clause and the search criteria and
 * build up the search query, then updates the index according to the search results.
 */
    void doSerach() {
        String where = "";

        String seword = jtxt_search.getText();

        String cat = jtr_search.getValue();

        if (!cat.equals("") && !cat.equals("0") && cat != null) {
            where += "`cat_id`='" + cat + "' and ";
        }

        if (!seword.equals("")) {

            where += "`" + ac.ui.utils.comBoxGetValue(jcom_search) + "`like '%" + jtxt_search.getText() + "%' and ";
        }

        p.Where = where + " 1=1 ";

        p.indexsearch();
        p.indexUpdate();

    }

    private void pCLButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_pCLButton1ActionPerformed

        doSerach();
    }//GEN-LAST:event_pCLButton1ActionPerformed

    private void jtr_searchValueChanged(javax.swing.event.TreeSelectionEvent evt) {//GEN-FIRST:event_jtr_searchValueChanged
        // TODO add your handling code here:
        //  p.indexUpdate();
    }//GEN-LAST:event_jtr_searchValueChanged

    private void jtb_searchMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jtb_searchMouseClicked
        /* jtab_data.setSelectedIndex(0);
         p.FrameDataUpdateFromSearch();*/
    }//GEN-LAST:event_jtb_searchMouseClicked

    private void jbt_cancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_cancelActionPerformed
        // TODO add your handling code here:

        jlb_indexinfo.setText(p.setcancel(false, true));
    }//GEN-LAST:event_jbt_cancelActionPerformed

    private void jbt_deleteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_deleteActionPerformed

        jlb_indexinfo.setText(p.setdelete(true, true, true));
    }//GEN-LAST:event_jbt_deleteActionPerformed

    private void jbt_editActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_editActionPerformed
        p.dataSaveValues = ac.ui.utils.getDataFromComss(p.dataComponents);
        jlb_indexinfo.setText(p.setedit(true, true, true));
    }//GEN-LAST:event_jbt_editActionPerformed

    private void jbt_addActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_addActionPerformed

        p.dataSaveValues = ac.ui.utils.getDataFromComss(p.dataComponents);

        jlb_indexinfo.setText(p.setnew(true, true, true));

    }//GEN-LAST:event_jbt_addActionPerformed

    private void jtr_indexValueChanged(javax.swing.event.TreeSelectionEvent evt) {//GEN-FIRST:event_jtr_indexValueChanged

        String catid = jtr_index.getValue();

        if (!catid.equals("0")) {

            p.Where = "`cat_id`='" + jtr_index.getValue() + "'";
        } else {
            p.Where = "";
        }

        p.indexUpdate();

        jlb_indexinfo.setText(p.FrameDataupdate("frist"));

        // TODO add your handling code here:
    }//GEN-LAST:event_jtr_indexValueChanged

    private void jbt_lastActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_lastActionPerformed
        jlb_indexinfo.setText(p.FrameDataupdate("last"));
    }//GEN-LAST:event_jbt_lastActionPerformed

    private void jbt_nextActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_nextActionPerformed

        jlb_indexinfo.setText(p.FrameDataupdate("next"));
    }//GEN-LAST:event_jbt_nextActionPerformed

    private void jbt_prevActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_prevActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_jbt_prevActionPerformed

    private void jbt_prevMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jbt_prevMouseClicked
        // TODO add your handling code here:

        jlb_indexinfo.setText(p.FrameDataupdate("perv"));

        ac.GUI.index.updatePinfo("" + p.IndexID, "", true);
        jlb_blance.setText("" + p.getbalance("" + p.IndexID));
    }//GEN-LAST:event_jbt_prevMouseClicked

    private void jbt_fristActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_fristActionPerformed
        jlb_indexinfo.setText(p.FrameDataupdate("frist"));
        ac.GUI.index.updatePinfo("" + p.IndexID, "", true);
    }//GEN-LAST:event_jbt_fristActionPerformed

    private void jtb_indexKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtb_indexKeyReleased
        jlb_indexinfo.setText(p.FrameDataupdate());
        ac.GUI.index.updatePinfo("" + p.IndexID, "", true);
        jlb_blance.setText("" + p.getbalance("" + p.IndexID));
    }//GEN-LAST:event_jtb_indexKeyReleased

    private void jtb_indexKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtb_indexKeyPressed
        jlb_indexinfo.setText(p.getkeyPressed(evt));
        ac.GUI.index.updatePinfo("" + p.IndexID, "", true);
        jlb_blance.setText("" + p.getbalance("" + p.IndexID));
    }//GEN-LAST:event_jtb_indexKeyPressed

    private void jtb_indexKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtb_indexKeyTyped
    }//GEN-LAST:event_jtb_indexKeyTyped

    private void jtb_indexMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jtb_indexMouseClicked
        jlb_indexinfo.setText(p.FrameDataupdate());

        ac.GUI.index.updatePinfo("" + p.IndexID, "", true);

        jlb_blance.setText("" + p.getbalance("" + p.IndexID));
    }//GEN-LAST:event_jtb_indexMouseClicked

    private void jbt_printActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_printActionPerformed
        p.setPrint(REPORT_Products_file_print, sqlQuerys.SQL_ProductsFile + p.IndexID);

    }//GEN-LAST:event_jbt_printActionPerformed

    private void jbt_edit1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_edit1ActionPerformed
        jtab_data.setSelectedIndex(0);
        p.FrameDataUpdateFromSearch();
    }//GEN-LAST:event_jbt_edit1ActionPerformed

    private void jbt_delete1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_delete1ActionPerformed
        p.IndexID = Integer.parseInt(jtb_search.getValue());
        jlb_indexinfo.setText(p.setdelete(true, true, true));

        doSerach();


    }//GEN-LAST:event_jbt_delete1ActionPerformed

    private void jbt_print1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_print1ActionPerformed

        p.IndexID = Integer.parseInt(d.IndexGetValue(p.serachTabel));

        p.setPrint(REPORT_Products_file_print, sqlQuerys.SQL_ProductsFile + p.IndexID);

    }//GEN-LAST:event_jbt_print1ActionPerformed

    boolean showRepProduct = false;
    boolean showRepClient = false;
    boolean showRepPsproductCat = false;
    boolean showRepInventory = false;

    void updaterepPnales() {

        jp_retportNamesproduct.setVisible(false);
        jp_retportNamesClient.setVisible(false);
        jp_retportNamesproductCat.setVisible(false);
        jp_retportNamesInventory.setVisible(false);

        if (showRepProduct) {
            jp_retportNamesproduct.setVisible(true);
        }

        if (showRepClient) {
            jp_retportNamesClient.setVisible(true);
        }
        if (showRepPsproductCat) {
            jp_retportNamesproductCat.setVisible(true);
        }
        if (showRepInventory) {
            jp_retportNamesInventory.setVisible(true);
        }

        showRepProduct = false;
        showRepClient = false;
        showRepPsproductCat = false;
        showRepInventory = false;
    }
    private void jd_rep_viewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jd_rep_viewActionPerformed

        ac.engin.moves.sell s = new ac.engin.moves.sell();
        ac.engin.moves.newbay b = new ac.engin.moves.newbay();
        ac.engin.moves.inventoryInput in = new ac.engin.moves.inventoryInput();
        ac.engin.moves.inventoryOutput on = new ac.engin.moves.inventoryOutput();
        /*
        
        
         111	صنف	 	products_reportes	 
         112	مبيعات	 	products_reportes	 
         113	مشتريات	 	products_reportes	 
         114	المخازن	 	products_reportes	 
         115	ملف	 	products_reportes	111	 
         116	مبيعات صنف خلال فترة	 	products_reportes	112	 
         117	 مبيعات صنف لعميل خلال فترة	 	products_reportes	112	 
        
         118	 مشتريات صنف خلال فترة	 	products_reportes	113	 
         119	 مشتريات صنف  لمورد خلال فترة	 	products_reportes	113	 
        
        
         120	حالة المخازن	 	products_reportes	114	 
         121	وارد مخزن خلال فترة	 	products_reportes	114	 
         122	صادر مخزن خلال فترة	 	products_reportes	114	 
        
         123 حالة تصنيف
         125	وارد  صنف الى المخزن لعميل
         126	صادر صنف  من المخزن لعميل
        
         */
        String rtype = jtr_rep_type.getValue();
        //String where = "";
        switch (rtype) {

            case "175":

                p.retportProCard(jcom_produest.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());

                break;

            case "115":
                p.setPrint(REPORT_Products_file_print, sqlQuerys.SQL_ProductsFile + jcom_produest.getValue());

                break;
            case "116":

                s.reportViewForPorduect(jcom_produest.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());
                break;
            case "117":

                s.reportViewForPorduectClinte(jcom_produest.getValue(), jcom_client.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());
                break;
            case "118":

                b.reportViewForPorduect(jcom_produest.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());
                break;
            case "119":

                b.reportViewForPorduectClinte(jcom_produest.getValue(), jcom_client.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());
                break;
            case "123":

                p.setPrint(REPORT_Products_status_print, sqlQuerys.SQL_ProductsAll + " where  products.cat_id = '" + jcom_productCategory1.getValue() + "'");
                break;
            case "120":

                p.retportInventoryStatus(jcom_inventory.getValue());

                break;
            case "121":

                in.reportViewForPorduect(jcom_produest.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());

                break;
            case "125":

                in.reportViewForPorduectClinte(jcom_produest.getValue(), jcom_client.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());

                break;

            case "122":

                on.reportViewForPorduect(jcom_produest.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());

                break;
            case "126":

                on.reportViewForPorduectClinte(jcom_produest.getValue(), jcom_client.getValue(), jd_rep_from.getDate(), jd_rep_to.getDate());

                break;

        }

    }//GEN-LAST:event_jd_rep_viewActionPerformed


    private void jtr_rep_typeValueChanged(javax.swing.event.TreeSelectionEvent evt) {//GEN-FIRST:event_jtr_rep_typeValueChanged
        updaterepPnales();
        jlb_repTitle.setText(jtr_rep_type.getText());

        String rtype = jtr_rep_type.getValue();

        switch (rtype) {
            case "115":
            case "116":
            case "121":
            case "118":
            case "122":
            case "175":

                showRepProduct = true;

                break;

            case "120":

                showRepInventory = true;

                break;
            case "123":
                showRepPsproductCat = true;

                break;
            case "125":
            case "126":
            case "119":
            case "117":
                showRepProduct = true;
                showRepClient = true;
                break;

        }
        updaterepPnales();

    }//GEN-LAST:event_jtr_rep_typeValueChanged

    private void jtab_indexDeleteMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jtab_indexDeleteMouseClicked
        // TODO add your handling code here:
    }//GEN-LAST:event_jtab_indexDeleteMouseClicked

    private void jtab_indexDeleteKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtab_indexDeleteKeyPressed
        // TODO add your handling code here:
    }//GEN-LAST:event_jtab_indexDeleteKeyPressed

    private void jtab_indexDeleteKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtab_indexDeleteKeyReleased
        // TODO add your handling code here:
    }//GEN-LAST:event_jtab_indexDeleteKeyReleased

    private void jtab_indexDeleteKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jtab_indexDeleteKeyTyped
        // TODO add your handling code here:
    }//GEN-LAST:event_jtab_indexDeleteKeyTyped

    private void jbt_removeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_removeActionPerformed

        String myid = d.IndexGetValue(p.deleteTabel);
        if (p.setRemove(Integer.parseInt(myid)) > 0) {
            p.removebalance(myid);
        }
        p.indexdelete();

    }//GEN-LAST:event_jbt_removeActionPerformed

    private void jbt_removeAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_removeAllActionPerformed
        p.removeAll();
        p.indexdelete();
    }//GEN-LAST:event_jbt_removeAllActionPerformed

    private void jbt_restoreActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_restoreActionPerformed
        p.setRestore(Integer.parseInt(d.IndexGetValue(p.deleteTabel)));
        p.indexdelete();
    }//GEN-LAST:event_jbt_restoreActionPerformed

    private void jbt_restoreAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbt_restoreAllActionPerformed
        p.setRestoreAll();
        p.indexdelete();
    }//GEN-LAST:event_jbt_restoreAllActionPerformed

    private void jtab_indexDeleteVetoableChange(java.beans.PropertyChangeEvent evt)throws java.beans.PropertyVetoException {//GEN-FIRST:event_jtab_indexDeleteVetoableChange


    }//GEN-LAST:event_jtab_indexDeleteVetoableChange

    private void jtab_indexDeletePropertyChange(java.beans.PropertyChangeEvent evt) {//GEN-FIRST:event_jtab_indexDeletePropertyChange
        // TODO add your handling code here:
    }//GEN-LAST:event_jtab_indexDeletePropertyChange

    private void jtab_indexDeleteCaretPositionChanged(java.awt.event.InputMethodEvent evt) {//GEN-FIRST:event_jtab_indexDeleteCaretPositionChanged

    }//GEN-LAST:event_jtab_indexDeleteCaretPositionChanged

    private void jcom_produestActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcom_produestActionPerformed


    }//GEN-LAST:event_jcom_produestActionPerformed

    private void jcom_produestMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jcom_produestMouseClicked

    }//GEN-LAST:event_jcom_produestMouseClicked

    private void jcom_clientActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcom_clientActionPerformed


    }//GEN-LAST:event_jcom_clientActionPerformed

    private void jcom_inventoryActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcom_inventoryActionPerformed


    }//GEN-LAST:event_jcom_inventoryActionPerformed

    private void jlb_blanceMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jlb_blanceMouseClicked
        updateBalencitem b = new updateBalencitem("p", "" + p.IndexID);
        b.setVisible(true);


    }//GEN-LAST:event_jlb_blanceMouseClicked

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private ac.ui.controls.PCLPanel data_panel;
    private ac.ui.controls.PCLPanel index_panel;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPsellpanel;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane11;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JScrollPane jScrollPane8;
    private org.jdesktop.swingx.JXLabel jXLabel1;
    private ac.ui.controls.PCLButton jbt_add;
    private ac.ui.controls.PCLButton jbt_cancel;
    private ac.ui.controls.PCLButton jbt_delete;
    private ac.ui.controls.PCLButton jbt_delete1;
    private ac.ui.controls.PCLButton jbt_edit;
    private ac.ui.controls.PCLButton jbt_edit1;
    private ac.ui.controls.PCLButton jbt_frist;
    private ac.ui.controls.PCLButton jbt_last;
    private ac.ui.controls.PCLButton jbt_next;
    private ac.ui.controls.PCLButton jbt_prev;
    private ac.ui.controls.PCLButton jbt_print;
    private ac.ui.controls.PCLButton jbt_print1;
    private ac.ui.controls.PCLButton jbt_remove;
    private ac.ui.controls.PCLButton jbt_removeAll;
    private ac.ui.controls.PCLButton jbt_restore;
    private ac.ui.controls.PCLButton jbt_restoreAll;
    private ac.ui.controls.PCLGetdata jcom_client;
    private ac.ui.controls.PCLGetdataFull jcom_inventory;
    private ac.ui.controls.PCLGetdata jcom_productCategory;
    private ac.ui.controls.PCLGetdata jcom_productCategory1;
    private ac.ui.controls.PCLGetdata jcom_produest;
    private ac.ui.controls.PCLcomboBox jcom_search;
    private ac.ui.controls.PCLDate jd_rep_from;
    private ac.ui.controls.PCLDate jd_rep_to;
    private ac.ui.controls.PCLButton jd_rep_view;
    private ac.ui.controls.PCLLabel jlb_blance;
    private ac.ui.controls.PCLLabel jlb_indexinfo;
    private ac.ui.controls.PCLLabel jlb_repTitle;
    private javax.swing.JLabel jlb_type;
    private javax.swing.JPanel jp_bayPric;
    private ac.ui.controls.PCLPanel jp_retportNamesClient;
    private ac.ui.controls.PCLPanel jp_retportNamesInventory;
    private ac.ui.controls.PCLPanel jp_retportNamesproduct;
    private ac.ui.controls.PCLPanel jp_retportNamesproductCat;
    private ac.ui.controls.PCLPanel jp_retportTaype;
    private ac.ui.controls.PCLPanel jp_retportcon;
    private ac.ui.controls.PCLTextarea jta_productDescription;
    private ac.ui.controls.PCLTabs jtab_data;
    private ac.ui.controls.PCLTable jtab_indexDelete;
    private ac.ui.controls.PCLTable jtb_index;
    private ac.ui.controls.PCLTable jtb_search;
    private ac.ui.controls.PCLTree jtr_index;
    private ac.ui.controls.PCLTree jtr_rep_type;
    private ac.ui.controls.PCLTree jtr_search;
    private ac.ui.controls.PCLCode jtxt_ProductCode;
    private ac.ui.controls.PCLMoney jtxt_ProductMax;
    private ac.ui.controls.PCLMoney jtxt_ProductMin;
    private ac.ui.controls.PCLMoney jtxt_ProductSellPriceFrom;
    private ac.ui.controls.PCLMoney jtxt_ProductSellPriceTo;
    private ac.ui.controls.PCLMoney jtxt_ProductbayPriceFrom;
    private ac.ui.controls.PCLMoney jtxt_ProductbayPriceTo;
    private ac.ui.controls.PCLTextField jtxt_productName;
    private ac.ui.controls.PCLTextField jtxt_search;
    private ac.ui.controls.PCLButton pCLButton1;
    private ac.ui.controls.PCLImage pCLImage1;
    private ac.ui.controls.PCLLabel pCLLabel1;
    private ac.ui.controls.PCLLabel pCLLabel10;
    private ac.ui.controls.PCLLabel pCLLabel12;
    private ac.ui.controls.PCLLabel pCLLabel13;
    private ac.ui.controls.PCLLabel pCLLabel14;
    private ac.ui.controls.PCLLabel pCLLabel15;
    private ac.ui.controls.PCLLabel pCLLabel16;
    private ac.ui.controls.PCLLabel pCLLabel17;
    private ac.ui.controls.PCLLabel pCLLabel18;
    private ac.ui.controls.PCLLabel pCLLabel19;
    private ac.ui.controls.PCLLabel pCLLabel2;
    private ac.ui.controls.PCLLabel pCLLabel20;
    private ac.ui.controls.PCLLabel pCLLabel21;
    private ac.ui.controls.PCLLabel pCLLabel22;
    private ac.ui.controls.PCLLabel pCLLabel4;
    private ac.ui.controls.PCLLabel pCLLabel5;
    private ac.ui.controls.PCLLabel pCLLabel6;
    private ac.ui.controls.PCLLabel pCLLabel7;
    private ac.ui.controls.PCLLabel pCLLabel8;
    private ac.ui.controls.PCLLabel pCLLabel9;
    private ac.ui.controls.PCLPanel pCLPanel1;
    private ac.ui.controls.PCLPanel pCLPanel2;
    private ac.ui.controls.PCLPanel pCLPanel3;
    private ac.ui.controls.PCLToolbar pCLToolbar1;
    private ac.ui.controls.PCLToolbar pCLToolbar2;
    private ac.ui.controls.PCLToolbar pCLToolbar8;
    private ac.ui.controls.PCLToolbar pCLToolbar9;
    // End of variables declaration//GEN-END:variables
}
